{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Two assets","Three assets","Sheet3"],"not_rendered":{"charts":2,"images":0,"macros":1,"external_links":0,"defined_names":39,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Two assets","index":0,"n_rows":36,"n_cols":9,"rows_kept":36,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"E(Rs)",8,null,"sd(Rs)",15,null,"rho",0.2]
[null,"E(Rb)",3,null,"sd(Rb)",5]
[]
[]
[]
[]
[]
[]
[null,"Ws","Wb","E(Rp)","SD(Rp)"]
[null,0,{"$f":"1-B12","v":1},{"$f":"B12*$C$3+C12*$C$4","v":3},{"$f":"SQRT(B12^2*$F$3^2+C12^2*$F$4^2+2*B12*C12*$I$3*$F$3*$F$4)","v":5}]
[null,0.05,{"$f":"1-B13","v":0.95},{"$f":"B13*$C$3+C13*$C$4","v":3.2499999999999996},4.9547956567349978]
[null,0.1,0.9,3.5,5.0199601592044534]
[null,0.15,0.85,3.75,5.1913389409669639]
[null,0.2,0.8,4,5.4589376255824726]
[null,0.25,0.75,4.25,5.8094750193111251]
[null,0.3,0.7,4.5,6.2289646009589745]
[null,0.35,0.65,4.75,6.7044761167446936]
[null,0.4,0.6,5,7.2249567472753773]
[null,0.45,0.55000000000000004,5.25,7.7813880509842202]
[null,0.5,0.5,5.5,8.3666002653407556]
[null,0.55000000000000004,0.44999999999999996,5.75,8.9749651809909547]
[null,0.6,0.4,6,9.6020831073262425]
[null,0.65,0.35,6.25,10.244510725261604]
[null,0.7,0.30000000000000004,6.5,10.89954127475097]
[null,0.75,0.25,6.75,11.565033506220377]
[null,0.8,0.19999999999999996,7,12.239281024635394]
[null,0.85,0.15000000000000002,7.25,12.920913280414815]
[null,0.9,9.9999999999999978E-2,7.5,13.608820668963199]
[null,0.95,5.0000000000000044E-2,7.75,14.302097748232599]
[null,1,0,8,15]
[null,1.05,-5.0000000000000044E-2,8.25,15.701910711757344]
[null,1.1000000000000001,-0.10000000000000009,8.5,16.40731544159495]
[null,1.1499999999999999,-0.14999999999999991,8.75,17.115782190715091]
[null,1.2,-0.19999999999999996,9,17.826945896591486]

{"sheet":"Three assets","index":1,"n_rows":30,"n_cols":8,"rows_kept":30,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
["E(Ra)",3,null,"SD(Ra)",5,null,"rho(Ra,Rb)",0]
["E(Rb)",7,null,"SD(Rb)",10,null,"rho(Ra,Rc)",0]
["E(Rc )",13,null,"SD(Rc)",18,null,"rho(Rb,Rc)",0]
[]
[]
[null,"Wa","Wb","Wc","E(Rp)","SD(Rp)"]
[null,1.0000000069730943,0,{"$f":"1-B10-C10","v":-6.9730943241808063E-9},{"$f":"B10*$B$4+C10*$B$5+D10*$B$6","v":2.9999999302690572},{"$f":"SQRT(B10^2*$E$4^2+C10^2*$E$5^2+D10^2*$E$6^2+2*B10*C10*$H$4*$E$4*$E$5+2*B10*D10*$H$5*$E$4*$E$6+2*C10*D10*$H$6*$E$5*$E$6)","v":5.0000000348654732}]
[null,0.87499919022566797,0.12500081629002183,{"$f":"1-B11-C11","v":-6.51568979326278E-9},3.5000032000031895,{"$f":"SQRT(B11^2*$E$4^2+C11^2*$E$5^2+D11^2*$E$6^2+2*B11*C11*$H$4*$E$4*$E$5+2*B11*D11*$H$5*$E$4*$E$6+2*C11*D11*$H$6*$E$5*$E$6)","v":4.5500670302432429}]
[null,0.80129272074731894,0.16451157553258361,3.4195703720097448E-2,4.0000033393313092,4.374588507509138]
[null,0.72991791692027641,0.20013681121084367,6.9945271868879916E-2,4.4999999635321739,4.3485741293672699]
[null,0.65854264194220147,0.23576227124258384,0.10569508681521469,4.999999953122483,4.4743597733820293]
[null,0.58716735645560147,0.27138772303972447,{"$f":"1-B15-C15","v":0.14144492050467405},{"$f":"B15*$B$4+C15*$B$5+D15*$B$6","v":5.5000000972056391},{"$f":"SQRT(B15^2*$E$4^2+C15^2*$E$5^2+D15^2*$E$6^2+2*B15*C15*$H$4*$E$4*$E$5+2*B15*D15*$H$5*$E$4*$E$6+2*C15*D15*$H$6*$E$5*$E$6)","v":4.7398762502511538}]
[null,0.51579151690373815,0.30701346817226538,0.17719501492399647,{"$f":"B16*$B$4+C16*$B$5+D16*$B$6","v":6.0000040219290263},{"$f":"SQRT(B16^2*$E$4^2+C16^2*$E$5^2+D16^2*$E$6^2+2*B16*C16*$H$4*$E$4*$E$5+2*B16*D16*$H$5*$E$4*$E$6+2*C16*D16*$H$6*$E$5*$E$6)","v":5.1234485398383098}]
[null,0.44441620319298647,0.34263895199857453,{"$f":"1-B17-C17","v":0.212944844808439},{"$f":"B17*$B$4+C17*$B$5+D17*$B$6","v":6.5000042560786877},{"$f":"SQRT(B17^2*$E$4^2+C17^2*$E$5^2+D17^2*$E$6^2+2*B17*C17*$H$4*$E$4*$E$5+2*B17*D17*$H$5*$E$4*$E$6+2*C17*D17*$H$6*$E$5*$E$6)","v":5.6008689887961767}]
[null,0.37304085826433703,0.37826444210607901,0.24869469962958402,7.0000047647201562,6.1503235068306958]
[null,0.30166626141206621,0.41388956575949093,0.28444417282844286,7.499999991322392,6.7542483321298468]
[null,0.23029097698580428,0.44951504130982839,0.32019398170436736,7.9999999822829873,7.3993284713132121]
[null,0.1589157068069294,0.48514049570461892,0.35594379748845173,8.4999999577029932,8.0757033676604895]
[null,8.7540408602318223E-2,0.52076599105763599,0.39169360034004574,8.9999999676310019,8.7761404286862508]
[null,1.9482632687192428E-2,0.55086224967046438,0.42965511764234321,9.5000001751052885,9.4955753724183545]
[null,0,0.4999999963242221,0.5000000036757779,10.000000022054667,10.295630180973589]
[null,0,0.41666666457340001,0.58333333542659993,10.5000000125596,11.296508829188202]
[null,0,0.3333333320760431,0.6666666679239569,11.000000007543742,12.454361146620133]
[null,0,0.24999999885204335,0.75000000114795662,11.50000000688774,13.729530235973447]
[null,0,0.1666655666655667,0.83333443333443324,12.000006600006598,15.092327027737685]
[null,0,8.3332199999999981E-2,0.91666780000000003,12.5000068,16.521050171102932]
[null,0,0,1,13,18]

{"sheet":"Sheet3","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}